package com.zetyun.tiger.sql.meta.col;

import cn.hutool.core.date.DateUtil;
import cn.hutool.core.text.StrFormatter;
import cn.hutool.core.util.NumberUtil;

public class GenWindowApp {

    public static void main(String[] args) {
        int hour = 24;
        int minute = 60;

        String format = "insert into DIM_HOUR_MINUTE values ('{}','{}','{}','{}'); ";



        for (int i = 0; i < hour; i++) {
            for (int j = 0; j < minute; j++) {
                String sh = String.format("%02d",i);
                String sm = String.format("%02d",j);
                int ehInt = i;
                int emInt = j;
                if (j!=59) {

                    emInt++;
                } else {
                    if (i!=23) {
                        ehInt = i+1;
                    } else {
                        ehInt = 0;
                    }
                    emInt =0;
                }
                String eh = String.format("%02d",ehInt);
                String em = String.format("%02d",emInt);

                System.out.println(StrFormatter.format(format,sh,sm,eh,em));
            }
        }
    }
}
